Attendance System
A realtime seat selection web application for students across the school.
Description
Attendance System
An attendance system for students and teachers, supporting real-time interaction between users. Constructed with Python, Redis, MySQL, React, FastAPI, and Websocket.
Overview
This project is used to assist students in class attendance, with the improvement of real-time seat selection instead of merely form-based submission. Here is the firstlook of how it works in the capture of realtime seat selection page and front-end workflow:
To have a deeper understanding of the project, you can watch 2 story boards of the project below, one is for the front pages and the other is for handling logic tasks under the hood:
Story cards for front pages from when the student log in
Story cards for handling logic tasks while student selecting seats
Database Design
For this project, MySQL is used as primary storage to store data and Redis for caching. With the primary storage, the data is mainly centered around room_session, which is the main table that stores the information of the class time frame. Room_session_seats table will be synced with Redis to capture the real-time seat selection:
Primary Database Design
Redis Workflow Design
Tech stack
Python
FastAPI
React
HTML
CSS
JavaScript
MySQL
Redis
Git
Websocket
Docker